﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="RestauraContraseña.aspx.vb" Inherits="ASI_2_UFG.RestauraContraseña" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Restaurar Contraseña</title>
    <link href="CSS/ASI2UFG.css" rel="stylesheet" type="text/css" />
</head>
<body>
    
    <div class="CONTENEDOR">
         <div class="ENCABEZADO">
            <img src="IMAGES/logoufg2012.png" class="LOGO" />
            <h1>Restaurar Contraseña</h1>
         </div>
         <div  class="CONTENIDO">
         <br />
         <br />
            <form id="rscon" runat="server" class="tableform">
                <fieldset><legend>Restaurar Contraseña</legend></fieldset>
                <br />
                <table>
                    <tr>
                        <td>
                            <asp:Label ID="Label1" runat="server" Text="Correo Electronico"></asp:Label></td>
                        <td>
                            <asp:TextBox ID="txtCorreo" runat="server"></asp:TextBox></td>
                    </tr>
                    <tr>
                        <td colspan="2">
                            <asp:Button ID="btnRestaurar" runat="server" Text="RESTAURAR"  CssClass="button-bevel green"/>
                            <asp:SqlDataSource ID="SQLPERSONAL" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:ASI2UFG %>" 
                                SelectCommand="SELECT [id_personal], [email], [clave] FROM [PERSONAL] WHERE ([email] = @email)">
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="txtCorreo" Name="email" PropertyName="Text" 
                                        Type="String" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:SqlDataSource ID="SQLESTUDIANTE" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:ASI2UFG %>" 
                                SelectCommand="SELECT [id_estudiante], [email], [clave] FROM [ESTUDIANTE] WHERE ([email] = @email)">
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="txtCorreo" Name="email" PropertyName="Text" 
                                        Type="String" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                        </td>
                    </tr>
                    <tr>
                        <asp:SqlDataSource ID="Stored" runat="server" 
                            ConnectionString="Data Source=EMANUEL-HP;Initial Catalog=upExcel;Integrated Security=True" 
                            ProviderName="System.Data.SqlClient" SelectCommand="RNDPSWD" 
                            SelectCommandType="StoredProcedure">
                            <SelectParameters>
                                <asp:ControlParameter ControlID="txtCorreo" Name="carnet" PropertyName="Text" 
                                    Type="String" />
                            </SelectParameters>
                        </asp:SqlDataSource>
                    <td>
                        <asp:Label ID="lblmensaje" runat="server" Text=""></asp:Label></td>
                    </tr>
                </table>
            </form>
         </div>  
         <br />
         <br />
         <div class="PIE">
            <p>proyecto de ASI2</p>
         </div>
    </div>
</body>
</html>
